formulas can either be entered into the textfields at the bottom or directly into cells. when you are entering formulas into the textfields at the bottom, you have to specify the row number and the column number of the cell in which you want the result of the formula displayed.
for the spreadsheet to recognise that you are entering a formula, the formula has to start with a = and end with a ;. example: =3+4; the result 7 will be displayed in the specified cell. addition, multiplication, division and subtraction can be calculated and brackets can be used. multiplications and divisions are calculated before additions and subtractions.
a cell reference has to be in the following form: ={row@column}; this means that cell references have to be enclosed within {} and the row number and column number have to be separated by a @. example: ={34@45}*2; this would take the value of the number in row 34 column 45 and multiply it with two.
references to other tables can only be made to already saved tables. if one table references to another table, the changes of the referenced table will only become visible, when the table is saved and the update cells button is pressed in the referencing table. there are two different kinds of references: a, references to files on the local system and b, references to files on the internet.
references to files on the local system: ={file://path\file.html@row@column}; this means that such a reference always has to start with file://, then the path to the file, e.g. c:\examples\spreadsheetfiles\ and finally the files name, like balancesheet.html. note that you might have to replace the \ with your local systems separator character. the \ works on microsoft windows systems. here an example: ={file://c:\econfiles\anotherfolder\test.html};
references to files on the internet:={http://url/file.html@row@column}; references to files on the internet have to start with http:// followed by the url of the file, e.g. www.mycompany.comand the files name. an example would be: ={http://econ.terrashare.com/balance.html@2@3}; this file really exists and can be used for testing.
before you can save a table, you will be asked to enter the area of your table, which you want to save. the maximum table area is preselected, but you should only save the area you really need, because files are saved in the html format and tables with 100 rows and 100 columns are quite slow for downloading and might even crash older browsers. that's why you should only save the area of the table which has useful information!!!
the function assistant helps you to do common mathematical calculations automatically. first, choose a function you want to perform, then choose the area of the table on which you want to apply the function on and finally choose a cell in which to display the result.
please contact earth connected for any further questions, comments or suggestions: [email protected]